﻿CREATE TABLE [dbo].[ReservationsRooms] (
    [ReservationId] INT NOT NULL,
    [RoomId]        INT NOT NULL,
    [Count]         INT NULL,
    CONSTRAINT [PK_ReservationsRooms] PRIMARY KEY CLUSTERED ([ReservationId] ASC, [RoomId] ASC),
    CONSTRAINT [FK_ReservationsRooms_Reservation] FOREIGN KEY ([ReservationId]) REFERENCES [dbo].[Reservations] ([ReservationId]),
    CONSTRAINT [FK_ReservationsRooms_Room] FOREIGN KEY ([RoomId]) REFERENCES [dbo].[Room] ([RoomId])
);

